Technote Number: 1116590
Problem:
This issue was reported to Lotus Software Quality Engineering, and was
addressed in these Notes Client releases: 6.0.1 CF3, 6.0.2 CF2 and 6.0.3.
Excerpt from the Lotus Notes and Domino Release 6.0.1 CF3, 6.0.2 CF2 and 6.0.3
MR fix lists (available at http://www.lotus.com/ldd):
@functions
SPR# MCHG5DTENB - In R4/R5, when the offset parameter of the @Middle formula is
a negative number, a blank string is correctly returned. In R6 the offset
counts from "right to left" and returns the number of characters designated by
the last parameter - fixed this problem such that a blank string is returned in
R6 also. This regression was introduced in 6.0 and fixed in 6.0.3, 6.0.2 CF2,
and 6.0.1 CF3.
Workaround:
Check to see if the offset is negative prior to calling @Middle. For example:
@If(offset<0;"";@Middle(inputstring, offset, numberofchars))
Related document:
@Middle and @MiddleBack Return an Empty String if Substring Is not Found
Document #: 1104692 More >
|  |
|
|
|
|
|